﻿IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_action]') AND TYPE in (N'U'))
BEGIN
CREATE TABLE tb_action
(
    Id INT IDENTITY(1,1) NOT NULL,
    actioncode varchar(4) not null,
    actionname varchar(20) not null default(''),
    actionvalue varchar(20) not null default(''),
    CreateBy VARCHAR(100),
    CreateDate DATETIME DEFAULT(GETDATE()),
    UpdateBy VARCHAR(100),
    UpdateDate DATETIME,
	CONSTRAINT PK_action_Id PRIMARY KEY CLUSTERED (Id)
) 
END
GO
